/**
 * Created by 白雨浓 on 2018/1/24 9:10.
 */

export const template = `SELECT * FROM \`<%=tableName%>\`
WHERE state != 0<% variables.forEach(item=>{ %>
<if test="entity.<%=item.jName%> != null">AND \`<%=item.sName%>\` = #{entity.<%=item.jName%>}</if><%})%>
ORDER BY state DESC, id DESC
LIMIT #{start}, #{size}`;